﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Water.DA;
using System.Data.Common;

namespace demo.Pages
{
    public partial class InitData : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void SuperButton1_Click(object sender, EventArgs e)
        {
            //delete
            string _delete_sql = "DELETE FROM EMPLOYEES";
            Database _db = DatabaseFactory.CreateDatabase();
            DbCommand _del_comm = _db.CreateSqlCommand(_delete_sql);
            int _r=_db.ExecuteNonQuery(_del_comm);

            //insert
            string _insert_sql = @"SET IDENTITY_INSERT [dbo].[EMPLOYEES] ON
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (100, N'Steven', N'King', N'SKING', N'515.123.4567', CAST(0x00009C8000000000 AS DateTime), N'AD_PRES', 24000.0000, NULL, NULL, 90)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (101, N'Neena', N'Kochhar', N'NKOCHHAR', N'515.123.4568', CAST(0x0000800200000000 AS DateTime), N'AD_VP', 17000.0000, NULL, 100, 90)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (102, N'Lex', N'De Haan', N'LDEHAAN', N'515.123.4569', CAST(0x000084BC00000000 AS DateTime), N'AD_VP', 17000.0000, NULL, 100, 90)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (103, N'Alexander', N'Hunold', N'AHUNOLD', N'590.423.4567', CAST(0x0000806A00000000 AS DateTime), N'IT_PROG', 9000.0000, NULL, 102, 60)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (104, N'Bruce', N'Ernst', N'BERNST', N'590.423.4568', CAST(0x0000826100000000 AS DateTime), N'IT_PROG', 6000.0000, NULL, 103, 60)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (105, N'David', N'Austin', N'DAUSTIN', N'590.423.4569', CAST(0x00008B1400000000 AS DateTime), N'IT_PROG', 4800.0000, NULL, 103, 60)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (106, N'Valli', N'Pataballa', N'VPATABAL', N'590.423.4560', CAST(0x00008BF500000000 AS DateTime), N'IT_PROG', 4800.0000, NULL, 103, 60)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (107, N'Diana', N'Lorentz', N'DLORENTZ', N'590.423.5567', CAST(0x00008D6400000000 AS DateTime), N'IT_PROG', 4200.0000, NULL, 103, 60)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (108, N'Nancy', N'Greenberg', N'NGREENBE', N'515.124.4569', CAST(0x0000870100000000 AS DateTime), N'FI_MGR', 12000.0000, NULL, 101, 100)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (109, N'Daniel', N'Faviet', N'DFAVIET', N'515.124.4169', CAST(0x0000870000000000 AS DateTime), N'FI_ACCOUNT', 9000.0000, NULL, 108, 100)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (110, N'John', N'Chen', N'JCHEN', N'515.124.4269', CAST(0x00008B7300000000 AS DateTime), N'FI_ACCOUNT', 8200.0000, NULL, 108, 100)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (111, N'Ismael', N'Sciarra', N'ISCIARRA', N'515.124.4369', CAST(0x00008B7500000000 AS DateTime), N'FI_ACCOUNT', 7700.0000, NULL, 108, 100)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (112, N'Jose Manuel', N'Urman', N'JMURMAN', N'515.124.4469', CAST(0x00008C1300000000 AS DateTime), N'FI_ACCOUNT', 7800.0000, NULL, 108, 100)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (113, N'Luis', N'Popp', N'LPOPP', N'515.124.4567', CAST(0x00008E9300000000 AS DateTime), N'FI_ACCOUNT', 6900.0000, NULL, 108, 100)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (114, N'Den', N'Raphaely', N'DRAPHEAL', N'515.127.4561', CAST(0x0000877100000000 AS DateTime), N'PU_MAN', 11000.0000, NULL, 100, 30)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (115, N'Alexander', N'Khoo', N'AKHOO', N'515.127.4562', CAST(0x0000881300000000 AS DateTime), N'PU_CLERK', 3100.0000, NULL, 114, 30)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (116, N'Shelli', N'Baida', N'SBAIDA', N'515.127.4563', CAST(0x00008BCA00000000 AS DateTime), N'PU_CLERK', 2900.0000, NULL, 114, 30)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (117, N'Sigal', N'Tobias', N'STOBIAS', N'515.127.4564', CAST(0x00008B3100000000 AS DateTime), N'PU_CLERK', 2800.0000, NULL, 114, 30)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (118, N'Guy', N'Himuro', N'GHIMURO', N'515.127.4565', CAST(0x00008D1000000000 AS DateTime), N'PU_CLERK', 2600.0000, NULL, 114, 30)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (119, N'Karen', N'Colmenares', N'KCOLMENA', N'515.127.4566', CAST(0x00008E1C00000000 AS DateTime), N'PU_CLERK', 2500.0000, NULL, 114, 30)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (120, N'Matthew', N'Weiss', N'MWEISS', N'650.123.1234', CAST(0x000089BE00000000 AS DateTime), N'ST_MAN', 8000.0000, NULL, 100, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (121, N'Adam', N'Fripp', N'AFRIPP', N'650.123.2234', CAST(0x00008AC800000000 AS DateTime), N'ST_MAN', 8200.0000, NULL, 100, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (122, N'Payam', N'Kaufling', N'PKAUFLIN', N'650.123.3234', CAST(0x0000880200000000 AS DateTime), N'ST_MAN', 7900.0000, NULL, 100, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (123, N'Shanta', N'Vollman', N'SVOLLMAN', N'650.123.4234', CAST(0x00008B7F00000000 AS DateTime), N'ST_MAN', 6500.0000, NULL, 100, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (124, N'Kevin', N'Mourgos', N'KMOURGOS', N'650.123.5234', CAST(0x00008E7E00000000 AS DateTime), N'ST_MAN', 5800.0000, NULL, 100, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (125, N'Julia', N'Nayer', N'JNAYER', N'650.124.1214', CAST(0x00008B2900000000 AS DateTime), N'ST_CLERK', 3200.0000, NULL, 120, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (126, N'Irene', N'Mikkilineni', N'IMIKKILI', N'650.124.1224', CAST(0x00008CE000000000 AS DateTime), N'ST_CLERK', 2700.0000, NULL, 120, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (127, N'James', N'Landry', N'JLANDRY', N'650.124.1334', CAST(0x00008D4C00000000 AS DateTime), N'ST_CLERK', 2400.0000, NULL, 120, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (128, N'Steven', N'Markle', N'SMARKLE', N'650.124.1434', CAST(0x00008EEF00000000 AS DateTime), N'ST_CLERK', 2200.0000, NULL, 120, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (129, N'Laura', N'Bissot', N'LBISSOT', N'650.124.5234', CAST(0x00008B4C00000000 AS DateTime), N'ST_CLERK', 3300.0000, NULL, 121, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (130, N'Mozhe', N'Atkinson', N'MATKINSO', N'650.124.6234', CAST(0x00008B9300000000 AS DateTime), N'ST_CLERK', 2800.0000, NULL, 121, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (131, N'James', N'Marlow', N'JAMRLOW', N'650.124.7234', CAST(0x00008A9300000000 AS DateTime), N'ST_CLERK', 2500.0000, NULL, 121, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (132, N'TJ', N'Olson', N'TJOLSON', N'650.124.8234', CAST(0x00008DA200000000 AS DateTime), N'ST_CLERK', 2100.0000, NULL, 121, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (133, N'Jason', N'Mallin', N'JMALLIN', N'650.127.1934', CAST(0x0000899C00000000 AS DateTime), N'ST_CLERK', 3300.0000, NULL, 122, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (134, N'Michael', N'Rogers', N'MROGERS', N'650.127.1834', CAST(0x00008CBF00000000 AS DateTime), N'ST_CLERK', 2900.0000, NULL, 122, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (135, N'Ki', N'Gee', N'KGEE', N'650.127.1734', CAST(0x00008E9800000000 AS DateTime), N'ST_CLERK', 2400.0000, NULL, 122, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (136, N'Hazel', N'Philtanker', N'HPHILTAN', N'650.127.1634', CAST(0x00008ED000000000 AS DateTime), N'ST_CLERK', 2200.0000, NULL, 122, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (137, N'Renske', N'Ladwig', N'RLADWIG', N'650.121.1234', CAST(0x0000884C00000000 AS DateTime), N'ST_CLERK', 3600.0000, NULL, 123, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (138, N'Stephen', N'Stiles', N'SSTILES', N'650.121.2034', CAST(0x00008B8F00000000 AS DateTime), N'ST_CLERK', 3200.0000, NULL, 123, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (139, N'John', N'Seo', N'JSEO', N'650.121.2019', CAST(0x00008BFC00000000 AS DateTime), N'ST_CLERK', 2700.0000, NULL, 123, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (140, N'Joshua', N'Patel', N'JPATEL', N'650.121.1834', CAST(0x00008C3100000000 AS DateTime), N'ST_CLERK', 2500.0000, NULL, 123, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (141, N'Trenna', N'Rajs', N'TRAJS', N'650.121.8009', CAST(0x00008FA500000000 AS DateTime), N'ST_CLERK', 3500.0000, NULL, 124, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (142, N'Curtis', N'Davies', N'CDAVIES', N'650.121.2994', CAST(0x00008A8100000000 AS DateTime), N'ST_CLERK', 3100.0000, NULL, 124, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (143, N'Randall', N'Matos', N'RMATOS', N'650.121.2874', CAST(0x00008C1B00000000 AS DateTime), N'ST_CLERK', 2600.0000, NULL, 124, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (144, N'Peter', N'Vargas', N'PVARGAS', N'650.121.2004', CAST(0x00008C8F00000000 AS DateTime), N'ST_CLERK', 2500.0000, NULL, 124, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (145, N'John', N'Russell', N'JRUSSEL', N'011.44.1344.429268', CAST(0x00008A0900000000 AS DateTime), N'SA_MAN', 14000.0000, CAST(0.40 AS Numeric(2, 2)), 100, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (146, N'Karen', N'Partners', N'KPARTNER', N'011.44.1344.467268', CAST(0x00008A6900000000 AS DateTime), N'SA_MAN', 13500.0000, CAST(0.30 AS Numeric(2, 2)), 100, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (147, N'Alberto', N'Errazuriz', N'AERRAZUR', N'011.44.1344.429278', CAST(0x00008AA900000000 AS DateTime), N'SA_MAN', 12000.0000, CAST(0.30 AS Numeric(2, 2)), 100, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (148, N'Gerald', N'Cambrault', N'GCAMBRAU', N'011.44.1344.619268', CAST(0x00008E5E00000000 AS DateTime), N'SA_MAN', 11000.0000, CAST(0.30 AS Numeric(2, 2)), 100, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (149, N'Eleni', N'Zlotkey', N'EZLOTKEY', N'011.44.1344.429018', CAST(0x00008EC800000000 AS DateTime), N'SA_MAN', 10500.0000, CAST(0.20 AS Numeric(2, 2)), 100, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (150, N'Peter', N'Tucker', N'PTUCKER', N'011.44.1344.129268', CAST(0x00008A8200000000 AS DateTime), N'SA_REP', 10000.0000, CAST(0.30 AS Numeric(2, 2)), 145, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (151, N'David', N'Bernstein', N'DBERNSTE', N'011.44.1344.345268', CAST(0x00008AB700000000 AS DateTime), N'SA_REP', 9500.0000, CAST(0.25 AS Numeric(2, 2)), 145, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (152, N'Peter', N'Hall', N'PHALL', N'011.44.1344.478968', CAST(0x00008B4C00000000 AS DateTime), N'SA_REP', 9000.0000, CAST(0.25 AS Numeric(2, 2)), 145, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (153, N'Christopher', N'Olsen', N'COLSEN', N'011.44.1344.498718', CAST(0x00008C2A00000000 AS DateTime), N'SA_REP', 8000.0000, CAST(0.20 AS Numeric(2, 2)), 145, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (154, N'Nanette', N'Cambrault', N'NCAMBRAU', N'011.44.1344.987668', CAST(0x00008D2800000000 AS DateTime), N'SA_REP', 7500.0000, CAST(0.20 AS Numeric(2, 2)), 145, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (155, N'Oliver', N'Tuvault', N'OTUVAULT', N'011.44.1344.486508', CAST(0x00008E8500000000 AS DateTime), N'SA_REP', 7000.0000, CAST(0.15 AS Numeric(2, 2)), 145, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (156, N'Janette', N'King', N'JKING', N'011.44.1345.429268', CAST(0x0000891400000000 AS DateTime), N'SA_REP', 10000.0000, CAST(0.35 AS Numeric(2, 2)), 146, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (157, N'Patrick', N'Sully', N'PSULLY', N'011.44.1345.929268', CAST(0x0000893600000000 AS DateTime), N'SA_REP', 9500.0000, CAST(0.35 AS Numeric(2, 2)), 146, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (158, N'Allan', N'McEwen', N'AMCEWEN', N'011.44.1345.829268', CAST(0x000089CC00000000 AS DateTime), N'SA_REP', 9000.0000, CAST(0.35 AS Numeric(2, 2)), 146, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (159, N'Lindsey', N'Smith', N'LSMITH', N'011.44.1345.729268', CAST(0x00008AA900000000 AS DateTime), N'SA_REP', 8000.0000, CAST(0.30 AS Numeric(2, 2)), 146, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (160, N'Louise', N'Doran', N'LDORAN', N'011.44.1345.629268', CAST(0x00008BC100000000 AS DateTime), N'SA_REP', 7500.0000, CAST(0.30 AS Numeric(2, 2)), 146, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (161, N'Sarath', N'Sewall', N'SSEWALL', N'011.44.1345.529268', CAST(0x00008D0400000000 AS DateTime), N'SA_REP', 7000.0000, CAST(0.25 AS Numeric(2, 2)), 146, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (162, N'Clara', N'Vishney', N'CVISHNEY', N'011.44.1346.129268', CAST(0x00008B9F00000000 AS DateTime), N'SA_REP', 10500.0000, CAST(0.25 AS Numeric(2, 2)), 147, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (163, N'Danielle', N'Greene', N'DGREENE', N'011.44.1346.229268', CAST(0x00008D8C00000000 AS DateTime), N'SA_REP', 9500.0000, CAST(0.15 AS Numeric(2, 2)), 147, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (164, N'Mattea', N'Marvins', N'MMARVINS', N'011.44.1346.329268', CAST(0x00008EC300000000 AS DateTime), N'SA_REP', 7200.0000, CAST(0.10 AS Numeric(2, 2)), 147, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (165, N'David', N'Lee', N'DLEE', N'011.44.1346.529268', CAST(0x00008EE100000000 AS DateTime), N'SA_REP', 6800.0000, CAST(0.10 AS Numeric(2, 2)), 147, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (166, N'Sundar', N'Ande', N'SANDE', N'011.44.1346.629268', CAST(0x00008EFF00000000 AS DateTime), N'SA_REP', 6400.0000, CAST(0.10 AS Numeric(2, 2)), 147, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (167, N'Amit', N'Banda', N'ABANDA', N'011.44.1346.729268', CAST(0x00008F1B00000000 AS DateTime), N'SA_REP', 6200.0000, CAST(0.10 AS Numeric(2, 2)), 147, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (168, N'Lisa', N'Ozer', N'LOZER', N'011.44.1343.929268', CAST(0x00008AAA00000000 AS DateTime), N'SA_REP', 11500.0000, CAST(0.25 AS Numeric(2, 2)), 148, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (169, N'Harrison', N'Bloom', N'HBLOOM', N'011.44.1343.829268', CAST(0x00008C2300000000 AS DateTime), N'SA_REP', 10000.0000, CAST(0.20 AS Numeric(2, 2)), 148, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (170, N'Tayler', N'Fox', N'TFOX', N'011.44.1343.729268', CAST(0x00008BE900000000 AS DateTime), N'SA_REP', 9600.0000, CAST(0.20 AS Numeric(2, 2)), 148, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (171, N'William', N'Smith', N'WSMITH', N'011.44.1343.629268', CAST(0x00008D7400000000 AS DateTime), N'SA_REP', 7400.0000, CAST(0.15 AS Numeric(2, 2)), 148, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (172, N'Elizabeth', N'Bates', N'EBATES', N'011.44.1343.529268', CAST(0x00008D9100000000 AS DateTime), N'SA_REP', 7300.0000, CAST(0.15 AS Numeric(2, 2)), 148, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (173, N'Sundita', N'Kumar', N'SKUMAR', N'011.44.1343.329268', CAST(0x00008F1B00000000 AS DateTime), N'SA_REP', 6100.0000, CAST(0.10 AS Numeric(2, 2)), 148, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (174, N'Ellen', N'Abel', N'EABEL', N'011.44.1644.429267', CAST(0x0000897A00000000 AS DateTime), N'SA_REP', 11000.0000, CAST(0.30 AS Numeric(2, 2)), 149, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (175, N'Alyssa', N'Hutton', N'AHUTTON', N'011.44.1644.429266', CAST(0x00008AB200000000 AS DateTime), N'SA_REP', 8800.0000, CAST(0.25 AS Numeric(2, 2)), 149, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (176, N'Jonathon', N'Taylor', N'JTAYLOR', N'011.44.1644.429265', CAST(0x00008C2400000000 AS DateTime), N'SA_REP', 8600.0000, CAST(0.20 AS Numeric(2, 2)), 149, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (177, N'Jack', N'Livingston', N'JLIVINGS', N'011.44.1644.429264', CAST(0x00008C4200000000 AS DateTime), N'SA_REP', 8400.0000, CAST(0.20 AS Numeric(2, 2)), 149, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (178, N'Kimberely', N'Grant', N'KGRANT', N'011.44.1644.429263', CAST(0x00008DCE00000000 AS DateTime), N'SA_REP', 7000.0000, CAST(0.15 AS Numeric(2, 2)), 149, NULL)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (179, N'Charles', N'Johnson', N'CJOHNSON', N'011.44.1644.429262', CAST(0x00008EAF00000000 AS DateTime), N'SA_REP', 6200.0000, CAST(0.10 AS Numeric(2, 2)), 149, 80)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (180, N'Winston', N'Taylor', N'WTAYLOR', N'650.507.9876', CAST(0x00008BE900000000 AS DateTime), N'SH_CLERK', 3200.0000, NULL, 120, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (181, N'Jean', N'Fleaur', N'JFLEAUR', N'650.507.9877', CAST(0x00008C0700000000 AS DateTime), N'SH_CLERK', 3100.0000, NULL, 120, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (182, N'Martha', N'Sullivan', N'MSULLIVA', N'650.507.9878', CAST(0x00008DEA00000000 AS DateTime), N'SH_CLERK', 2500.0000, NULL, 120, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (183, N'Girard', N'Geoni', N'GGEONI', N'650.507.9879', CAST(0x00008ECD00000000 AS DateTime), N'SH_CLERK', 2800.0000, NULL, 120, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (184, N'Nandita', N'Sarchand', N'NSARCHAN', N'650.509.1876', CAST(0x0000891100000000 AS DateTime), N'SH_CLERK', 4200.0000, NULL, 121, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (185, N'Alexis', N'Bull', N'ABULL', N'650.509.2876', CAST(0x00008A9700000000 AS DateTime), N'SH_CLERK', 4100.0000, NULL, 121, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (186, N'Julia', N'Dellinger', N'JDELLING', N'650.509.3876', CAST(0x00008C8000000000 AS DateTime), N'SH_CLERK', 3400.0000, NULL, 121, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (187, N'Anthony', N'Cabrio', N'ACABRIO', N'650.509.4876', CAST(0x00008D6400000000 AS DateTime), N'SH_CLERK', 3000.0000, NULL, 121, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (188, N'Kelly', N'Chung', N'KCHUNG', N'650.505.1876', CAST(0x00008B0900000000 AS DateTime), N'SH_CLERK', 3800.0000, NULL, 122, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (189, N'Jennifer', N'Dilly', N'JDILLY', N'650.505.2876', CAST(0x00008B4500000000 AS DateTime), N'SH_CLERK', 3600.0000, NULL, 122, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (190, N'Timothy', N'Gates', N'TGATES', N'650.505.3876', CAST(0x00008C9100000000 AS DateTime), N'SH_CLERK', 2900.0000, NULL, 122, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (191, N'Randall', N'Perkins', N'RPERKINS', N'650.505.4876', CAST(0x00008E9F00000000 AS DateTime), N'SH_CLERK', 2500.0000, NULL, 122, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (192, N'Sarah', N'Bell', N'SBELL', N'650.501.1876', CAST(0x0000891900000000 AS DateTime), N'SH_CLERK', 4000.0000, NULL, 123, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (193, N'Britney', N'Everett', N'BEVERETT', N'650.501.2876', CAST(0x00008AA200000000 AS DateTime), N'SH_CLERK', 3900.0000, NULL, 123, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (194, N'Samuel', N'McCain', N'SMCCAIN', N'650.501.3876', CAST(0x00008C8700000000 AS DateTime), N'SH_CLERK', 3200.0000, NULL, 123, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (195, N'Vance', N'Jones', N'VJONES', N'650.501.4876', CAST(0x00008D8A00000000 AS DateTime), N'SH_CLERK', 2800.0000, NULL, 123, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (196, N'Alana', N'Walsh', N'AWALSH', N'650.507.9811', CAST(0x00008C4300000000 AS DateTime), N'SH_CLERK', 3100.0000, NULL, 124, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (197, N'Kevin', N'Feeney', N'KFEENEY', N'650.507.9822', CAST(0x00008C6000000000 AS DateTime), N'SH_CLERK', 3000.0000, NULL, 124, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (198, N'Donald', N'OConnell', N'liugq@tsingtao.com.cn', N'650.507.9833', CAST(0x00008DEA00000000 AS DateTime), N'SH_CLERK', 2600.0000, NULL, 124, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (199, N'Douglas', N'Grant', N'DGRANT', N'650.507.9844', CAST(0x00008EB800000000 AS DateTime), N'SH_CLERK', 2600.0000, NULL, 124, 50)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (200, N'Jennifer_200', N'Whalen_200', N'JWHALEN', N'515.123.4444', CAST(0x00007D2300000000 AS DateTime), N'AD_ASST', 4400.0000, NULL, 101, 10)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (201, N'Michael', N'Hartstein', N'MHARTSTE', N'515.123.5555', CAST(0x0000892600000000 AS DateTime), N'MK_MAN', 13000.0000, NULL, 100, 20)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (202, N'Pat111', N'Fay', N'PFAY', N'603.123.6666', CAST(0x00008B4900000000 AS DateTime), N'MK_REP', 6000.0000, NULL, 201, 20)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (203, N'Susan', N'Mavris', N'SMAVRIS', N'515.123.7777', CAST(0x000086BA00000000 AS DateTime), N'HR_REP', 6500.0000, NULL, 101, 40)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (204, N'Hermann', N'Baer', N'HBAER', N'515.123.8888', CAST(0x000086BA00000000 AS DateTime), N'PR_REP', 10000.0000, NULL, 101, 70)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (205, N'Shelley', N'Higgins', N'SHIGGINS', N'515.123.8080', CAST(0x000086BA00000000 AS DateTime), N'AC_MGR', 12000.0000, NULL, 101, 110)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (206, N'William', N'Gietz', N'WGIETZ', N'515.123.8181', CAST(0x000086BA00000000 AS DateTime), N'AC_ACCOUNT', 8300.0000, NULL, 205, 110)
;INSERT [dbo].[EMPLOYEES] ([EMPLOYEE_ID], [FIRST_NAME], [LAST_NAME], [EMAIL], [PHONE_NUMBER], [HIRE_DATE], [JOB_ID], [SALARY], [COMMISSION_PCT], [MANAGER_ID], [DEPARTMENT_ID]) VALUES (208, N'William', N'Gietz', N'liu_shangqi', NULL, NULL, NULL, NULL, NULL, NULL, NULL)
;SET IDENTITY_INSERT [dbo].[EMPLOYEES] OFF";

            DbCommand _insert_comm = _db.CreateSqlCommand(_insert_sql);
            int _i = _db.ExecuteNonQuery(_insert_comm);
        }
    }
}
